YData Profiling Report

Dataset statistics

Number of variables	13
Number of observations	21,613
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	6
Duplicate rows (%)	< 0.1%
Total size in memory	2.1 MiB
Average record size in memory	104.0 B

Variable types

Numeric	9
Categorical	4

Alerts

Dataset has 6 (< 0.1%) duplicate rows	Duplicates
`bathrooms` is highly overall correlated with `bedrooms` and 3 other fields	High correlation
`bedrooms` is highly overall correlated with `bathrooms` and 1 other fields	High correlation
`floors` is highly overall correlated with `bathrooms` and 1 other fields	High correlation
`grade` is highly overall correlated with `bathrooms` and 3 other fields	High correlation
`price` is highly overall correlated with `grade` and 1 other fields	High correlation
`sqft_living` is highly overall correlated with `bathrooms` and 3 other fields	High correlation
`view` is highly overall correlated with `waterfront`	High correlation
`waterfront` is highly overall correlated with `view`	High correlation
`waterfront` is highly imbalanced (93.6%)	Imbalance
`view` is highly imbalanced (72.2%)	Imbalance
`yr_renovated` is highly imbalanced (74.7%)	Imbalance

Reproduction

Analysis started	2026-01-31 11:39:40.477637
Analysis finished	2026-01-31 11:39:58.313364
Duration	17.84 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

price
Real number (ℝ)

High correlation

Distinct	4029
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	540088.58

Minimum	75000
Maximum	7700000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	75000
5-th percentile	210000
Q1	321950
median	450000
Q3	645000
95-th percentile	1156480
Maximum	7700000
Range	7625000
Interquartile range (IQR)	323050

Descriptive statistics

Standard deviation	367126.83
Coefficient of variation (CV)	0.67975299
Kurtosis	34.585671
Mean	540088.58
Median Absolute Deviation (MAD)	150000
Skewness	4.0240804
Sum	1.1672934 × 10¹⁰
Variance	1.3478211 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
350000	172	0.8%
450000	172	0.8%
550000	159	0.7%
500000	152	0.7%
425000	150	0.7%
325000	148	0.7%
400000	145	0.7%
375000	138	0.6%
300000	133	0.6%
525000	131	0.6%
Other values (4019)	20113	93.1%

Value	Count	Frequency (%)
75000	1	< 0.1%
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82000	1	< 0.1%
82500	1	< 0.1%
83000	1	< 0.1%
84000	1	< 0.1%
85000	2	< 0.1%
86500	1	< 0.1%

Value	Count	Frequency (%)
7700000	1	< 0.1%
7062500	1	< 0.1%
6885000	1	< 0.1%
5570000	1	< 0.1%
5350000	1	< 0.1%
5300000	1	< 0.1%
5110800	1	< 0.1%
4668000	1	< 0.1%
4500000	1	< 0.1%
4489000	1	< 0.1%

bedrooms
Real number (ℝ)

High correlation

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3707954

Minimum	0
Maximum	33
Zeros	13
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	33
Range	33
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.93010515
Coefficient of variation (CV)	0.27593047
Kurtosis	49.054564
Mean	3.3707954
Median Absolute Deviation (MAD)	1
Skewness	1.9740277
Sum	72853
Variance	0.8650956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
3	9823	45.4%
4	6882	31.8%
2	2761	12.8%
5	1601	7.4%
6	272	1.3%
1	199	0.9%
7	38	0.2%
0	13	0.1%
8	13	0.1%
9	6	< 0.1%
Other values (3)	5	< 0.1%

Value	Count	Frequency (%)
0	13	0.1%
1	199	0.9%
2	2761	12.8%
3	9823	45.4%
4	6882	31.8%
5	1601	7.4%
6	272	1.3%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
33	1	< 0.1%
11	1	< 0.1%
10	3	< 0.1%
9	6	< 0.1%
8	13	0.1%
7	38	0.2%
6	272	1.3%
5	1601	7.4%
4	6882	31.8%
3	9823	45.4%

bathrooms
Real number (ℝ)

High correlation

Distinct	30
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1147573

Minimum	0
Maximum	8
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1.75
median	2.25
Q3	2.5
95-th percentile	3.5
Maximum	8
Range	8
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.77016316
Coefficient of variation (CV)	0.36418512
Kurtosis	1.2799024
Mean	2.1147573
Median Absolute Deviation (MAD)	0.5
Skewness	0.51110757
Sum	45706.25
Variance	0.59315129
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
2.5	5380	24.9%
1	3852	17.8%
1.75	3048	14.1%
2.25	2047	9.5%
2	1930	8.9%
1.5	1446	6.7%
2.75	1185	5.5%
3	753	3.5%
3.5	731	3.4%
3.25	589	2.7%
Other values (20)	652	3.0%

Value	Count	Frequency (%)
0	10	< 0.1%
0.5	4	< 0.1%
0.75	72	0.3%
1	3852	17.8%
1.25	9	< 0.1%
1.5	1446	6.7%
1.75	3048	14.1%
2	1930	8.9%
2.25	2047	9.5%
2.5	5380	24.9%

Value	Count	Frequency (%)
8	2	< 0.1%
7.75	1	< 0.1%
7.5	1	< 0.1%
6.75	2	< 0.1%
6.5	2	< 0.1%
6.25	2	< 0.1%
6	6	< 0.1%
5.75	4	< 0.1%
5.5	10	< 0.1%
5.25	13	0.1%

sqft_living
Real number (ℝ)

High correlation

Distinct	1038
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2079.8997

Minimum	290
Maximum	13540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	290
5-th percentile	940
Q1	1427
median	1910
Q3	2550
95-th percentile	3760
Maximum	13540
Range	13250
Interquartile range (IQR)	1123

Descriptive statistics

Standard deviation	918.4409
Coefficient of variation (CV)	0.44157941
Kurtosis	5.243093
Mean	2079.8997
Median Absolute Deviation (MAD)	540
Skewness	1.4715554
Sum	44952873
Variance	843533.68
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	138	0.6%
1400	135	0.6%
1440	133	0.6%
1800	129	0.6%
1660	129	0.6%
1010	129	0.6%
1820	128	0.6%
1480	125	0.6%
1720	125	0.6%
1540	124	0.6%
Other values (1028)	20318	94.0%

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
13540	1	< 0.1%
12050	1	< 0.1%
10040	1	< 0.1%
9890	1	< 0.1%
9640	1	< 0.1%
9200	1	< 0.1%
8670	1	< 0.1%
8020	1	< 0.1%
8010	1	< 0.1%
8000	1	< 0.1%

sqft_lot
Real number (ℝ)

Distinct	9782
Distinct (%)	45.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15106.968

Minimum	520
Maximum	1651359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	520
5-th percentile	1800
Q1	5040
median	7618
Q3	10688
95-th percentile	43339.2
Maximum	1651359
Range	1650839
Interquartile range (IQR)	5648

Descriptive statistics

Standard deviation	41420.512
Coefficient of variation (CV)	2.7418151
Kurtosis	285.07782
Mean	15106.968
Median Absolute Deviation (MAD)	2618
Skewness	13.060019
Sum	3.2650689 × 10⁸
Variance	1.7156588 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	358	1.7%
6000	290	1.3%
4000	251	1.2%
7200	220	1.0%
4800	120	0.6%
7500	119	0.6%
4500	114	0.5%
8400	111	0.5%
9600	109	0.5%
3600	103	0.5%
Other values (9772)	19818	91.7%

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	2	< 0.1%
651	1	< 0.1%
675	1	< 0.1%
676	1	< 0.1%

Value	Count	Frequency (%)
1651359	1	< 0.1%
1164794	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982998	1	< 0.1%
982278	1	< 0.1%
920423	1	< 0.1%
881654	1	< 0.1%
871200	2	< 0.1%
843309	1	< 0.1%

floors
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.494309

Minimum	1
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5399889
Coefficient of variation (CV)	0.36136361
Kurtosis	-0.48472294
Mean	1.494309
Median Absolute Deviation (MAD)	0.5
Skewness	0.61617672
Sum	32296.5
Variance	0.29158801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	10680	49.4%
2	8241	38.1%
1.5	1910	8.8%
3	613	2.8%
2.5	161	0.7%
3.5	8	< 0.1%

Value	Count	Frequency (%)
1	10680	49.4%
1.5	1910	8.8%
2	8241	38.1%
2.5	161	0.7%
3	613	2.8%
3.5	8	< 0.1%

Value	Count	Frequency (%)
3.5	8	< 0.1%
3	613	2.8%
2.5	161	0.7%
2	8241	38.1%
1.5	1910	8.8%
1	10680	49.4%

waterfront
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	169.0 KiB

0	21450
1	163

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21,613
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

view
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	169.0 KiB

0	19489
2	963
3	510
1	332
4	319

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21,613
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

condition
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	169.0 KiB

3	14031
4	5679
5	1701
2	172
1	30

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21,613
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	5
5th row	3

Common Values

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring characters

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

grade
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6568732

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	7
median	7
Q3	8
95-th percentile	10
Maximum	13
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1754588
Coefficient of variation (CV)	0.15351681
Kurtosis	1.1909321
Mean	7.6568732
Median Absolute Deviation (MAD)	1
Skewness	0.7711032
Sum	165488
Variance	1.3817033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	8981	41.6%
8	6068	28.1%
9	2615	12.1%
6	2038	9.4%
10	1134	5.2%
11	399	1.8%
5	242	1.1%
12	90	0.4%
4	29	0.1%
13	13	0.1%
Other values (2)	4	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
3	3	< 0.1%
4	29	0.1%
5	242	1.1%
6	2038	9.4%
7	8981	41.6%
8	6068	28.1%
9	2615	12.1%
10	1134	5.2%
11	399	1.8%

Value	Count	Frequency (%)
13	13	0.1%
12	90	0.4%
11	399	1.8%
10	1134	5.2%
9	2615	12.1%
8	6068	28.1%
7	8981	41.6%
6	2038	9.4%
5	242	1.1%
4	29	0.1%

yr_renovated
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	169.0 KiB

0	20699
1	914

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21,613
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	20699	95.8%
1	914	4.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	20699	95.8%
1	914	4.2%

Most occurring characters

Value	Count	Frequency (%)
0	20699	95.8%
1	914	4.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	20699	95.8%
1	914	4.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	20699	95.8%
1	914	4.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	20699	95.8%
1	914	4.2%

lat
Real number (ℝ)

Distinct	5034
Distinct (%)	23.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.560053

Minimum	47.1559
Maximum	47.7776
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	47.1559
5-th percentile	47.3103
Q1	47.471
median	47.5718
Q3	47.678
95-th percentile	47.74964
Maximum	47.7776
Range	0.6217
Interquartile range (IQR)	0.207

Descriptive statistics

Standard deviation	0.13856371
Coefficient of variation (CV)	0.0029134474
Kurtosis	-0.676313
Mean	47.560053
Median Absolute Deviation (MAD)	0.1049
Skewness	-0.48527048
Sum	1027915.4
Variance	0.019199902
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.6624	17	0.1%
47.5322	17	0.1%
47.6846	17	0.1%
47.5491	17	0.1%
47.6955	16	0.1%
47.6886	16	0.1%
47.6711	16	0.1%
47.5402	15	0.1%
47.6842	15	0.1%
47.6904	15	0.1%
Other values (5024)	21452	99.3%

Value	Count	Frequency (%)
47.1559	1	< 0.1%
47.1593	1	< 0.1%
47.1622	1	< 0.1%
47.1647	1	< 0.1%
47.1764	1	< 0.1%
47.1775	1	< 0.1%
47.1776	2	< 0.1%
47.1795	1	< 0.1%
47.1803	1	< 0.1%
47.1808	1	< 0.1%

Value	Count	Frequency (%)
47.7776	3	< 0.1%
47.7775	3	< 0.1%
47.7774	1	< 0.1%
47.7772	3	< 0.1%
47.7771	2	< 0.1%
47.777	2	< 0.1%
47.7769	3	< 0.1%
47.7768	2	< 0.1%
47.7767	6	< 0.1%
47.7766	4	< 0.1%

long
Real number (ℝ)

Distinct	752
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.2139

Minimum	-122.519
Maximum	-121.315
Zeros	0
Zeros (%)	0.0%
Negative	21613
Negative (%)	100.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	-122.519
5-th percentile	-122.387
Q1	-122.328
median	-122.23
Q3	-122.125
95-th percentile	-121.979
Maximum	-121.315
Range	1.204
Interquartile range (IQR)	0.203

Descriptive statistics

Standard deviation	0.14082834
Coefficient of variation (CV)	-0.0011523104
Kurtosis	1.0495009
Mean	-122.2139
Median Absolute Deviation (MAD)	0.101
Skewness	0.88505298
Sum	-2641408.9
Variance	0.019832622
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29	116	0.5%
-122.3	111	0.5%
-122.362	104	0.5%
-122.291	100	0.5%
-122.363	99	0.5%
-122.372	99	0.5%
-122.288	98	0.5%
-122.357	96	0.4%
-122.284	95	0.4%
-122.365	94	0.4%
Other values (742)	20601	95.3%

Value	Count	Frequency (%)
-122.519	1	< 0.1%
-122.515	1	< 0.1%
-122.514	1	< 0.1%
-122.512	1	< 0.1%
-122.511	2	< 0.1%
-122.509	2	< 0.1%
-122.507	1	< 0.1%
-122.506	1	< 0.1%
-122.505	3	< 0.1%
-122.504	2	< 0.1%

Value	Count	Frequency (%)
-121.315	2	< 0.1%
-121.316	1	< 0.1%
-121.319	1	< 0.1%
-121.321	1	< 0.1%
-121.325	1	< 0.1%
-121.352	2	< 0.1%
-121.359	1	< 0.1%
-121.364	2	< 0.1%
-121.402	1	< 0.1%
-121.403	1	< 0.1%

	bathrooms	bedrooms	condition	floors	grade	lat	long	price	sqft_living	sqft_lot	view	waterfront	yr_renovated
bathrooms	1.000	0.521	0.130	0.547	0.658	0.008	0.262	0.497	0.746	0.069	0.114	0.102	0.060
bedrooms	0.521	1.000	0.024	0.228	0.381	-0.021	0.191	0.345	0.647	0.217	0.038	0.000	0.021
condition	0.130	0.024	1.000	0.179	0.154	0.058	0.081	0.023	0.060	0.039	0.025	0.017	0.067
floors	0.547	0.228	0.179	1.000	0.502	0.025	0.149	0.322	0.401	-0.234	0.024	0.022	0.059
grade	0.658	0.381	0.154	0.502	1.000	0.104	0.223	0.658	0.716	0.152	0.143	0.118	0.013
lat	0.008	-0.021	0.058	0.025	0.104	1.000	-0.143	0.456	0.031	-0.122	0.068	0.034	0.059
long	0.262	0.191	0.081	0.149	0.223	-0.143	1.000	0.064	0.285	0.371	0.085	0.096	0.083
price	0.497	0.345	0.023	0.322	0.658	0.456	0.064	1.000	0.644	0.075	0.208	0.320	0.128
sqft_living	0.746	0.647	0.060	0.401	0.716	0.031	0.285	0.644	1.000	0.304	0.149	0.140	0.071
sqft_lot	0.069	0.217	0.039	-0.234	0.152	-0.122	0.371	0.075	0.304	1.000	0.040	0.014	0.000
view	0.114	0.038	0.025	0.024	0.143	0.068	0.085	0.208	0.149	0.040	1.000	0.592	0.109
waterfront	0.102	0.000	0.017	0.022	0.118	0.034	0.096	0.320	0.140	0.014	0.592	1.000	0.092
yr_renovated	0.060	0.021	0.067	0.059	0.013	0.059	0.083	0.128	0.071	0.000	0.109	0.092	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	yr_renovated	lat	long
0	231300.0	2	1.00	1180	5650	1.0	3	7	0	47.5112	-122.257
1	538000.0	3	2.25	2570	7242	2.0	3	7	1	47.7210	-122.319
2	180000.0	2	1.00	770	10000	1.0	3	6	0	47.7379	-122.233
3	604000.0	4	3.00	1960	5000	1.0	5	7	0	47.5208	-122.393
4	510000.0	3	2.00	1680	8080	1.0	3	8	0	47.6168	-122.045
5	1225000.0	4	4.50	5420	101930	1.0	3	11	0	47.6561	-122.005
6	257500.0	3	2.25	1715	6819	2.0	3	7	0	47.3097	-122.327
7	291850.0	3	1.50	1060	9711	1.0	3	7	0	47.4095	-122.315
8	229500.0	3	1.00	1780	7470	1.0	3	7	0	47.5123	-122.337
9	323000.0	3	2.50	1890	6560	2.0	3	7	0	47.3684	-122.031

	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	lat	long
21603	507250.0	3	2.50	2270	5536	2.0	3	8	47.5389	-121.881
21604	429000.0	3	2.00	1490	1126	3.0	3	8	47.5699	-122.288
21605	610685.0	4	2.50	2520	6023	2.0	3	9	47.5137	-122.167
21606	1007500.0	4	3.50	3510	7200	2.0	3	9	47.5537	-122.398
21607	475000.0	3	2.50	1310	1294	2.0	3	8	47.5773	-122.409
21608	360000.0	3	2.50	1530	1131	3.0	3	8	47.6993	-122.346
21609	400000.0	4	2.50	2310	5813	2.0	3	8	47.5107	-122.362
21610	402101.0	2	0.75	1020	1350	2.0	3	7	47.5944	-122.299
21611	400000.0	3	2.50	1600	2388	2.0	3	8	47.5345	-122.069
21612	325000.0	2	0.75	1020	1076	2.0	3	7	47.5941	-122.299

Most frequently occurring

	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	view	condition	grade	yr_renovated	lat	long	# duplicates
0	259950.0	2	2.00	1070	649	2.0	0	3	9	0	47.5213	-122.357	2
1	529500.0	3	2.25	1410	905	3.0	0	3	9	0	47.5818	-122.402	2
2	550000.0	4	1.75	2410	8447	2.0	3	4	8	1	47.6499	-122.088	2
3	555000.0	3	2.50	1940	3211	2.0	0	3	8	0	47.5644	-122.093	2
4	585000.0	3	2.50	2290	5089	2.0	0	3	9	0	47.5443	-122.172	2
5	635000.0	3	3.00	2230	1407	2.5	0	3	8	0	47.5446	-122.017	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring